<%-- 
    Document   : BiljettenVullen
    Created on : 10-jun-2009, 8:45:50
    Author     : frankkie
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h1>Hello World!</h1>
        <%
   String tabelNaam = "b_biljetten";
   String aantal = "25";
   eskuel.CMI_SQL sql = new eskuel.CMI_SQL(pak.Db.dbhost, pak.Db.dbname, pak.Db.dbpass);
   String sqlQuery = "UPDATE `cmi0806683`.`" + tabelNaam + "` SET `Aantal5`='"+aantal+"',`Aantal10`='"+aantal+"',`Aantal20`='"+aantal+"',`Aantal50`='"+aantal+"',`Aantal100`='"+aantal+"',`Aantal200`='"+aantal+"',`Aantal500`='"+aantal+"' WHERE `Pinautomaat` = '" + request.getParameter("a") + "'";
   System.out.println(sqlQuery);
   sql.updateQuery(sqlQuery);
   response.sendRedirect("Overzicht geldbiljetten in pinautomaat.jsp");
    %>
    </body>
</html>
